package com.atguigu.edusugar.mapper;

import com.atguigu.edusugar.bean.UserChangeCtPerType;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author cheng
 * @create 2022-10-29 9:30
 */
@Mapper
public interface TradeMapper {


    @Select("select 'cartAdd' type ," +
            "sum(cart_add_uu_ct) cartAdd " +
            " from edu.dws_trade_cart_add_uu_window " +
            "where toYYYYMMDD(stt) = #{date}")
     List<UserChangeCtPerType> tradeCartAdd(@Param("date") int date);

}
